package com.example.demo04;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

public interface TestMapper extends BaseMapper<TestEntity> {

    @Select("select count(*) from sqlite_master where type='table' and name='test_table'")
    Integer selectTable();

    @Select("""
    CREATE TABLE test_table(
       id TEXT PRIMARY KEY     NOT NULL,
       name           TEXT    NOT NULL
);
""")
    Integer createTestTable();
}
